package com.tedu.egmybatis1.mapper;

import com.tedu.egmybatis1.pojo.entity.Product;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ProductMapper {

//    @Insert("INSERT INTO product(title,price,stock) " +
//            "VALUES(#{title},#{price},#{stock}) ")
    int insertProduct(Product product);
//    @Delete("DELETE FROM product " +
//            "WHERE id = #{id}")
    int deleteById(Integer id);
//    @Update("UPDATE product " +
//            "SET title =#{title},price=#{price},stock=#{stock} " +
//            "WHERE id = #{id}")
    int updateById(Product product);
//    @Select("SELECT id,title,price,stock " +
//            "FROM product " +
//            "WHERE id = #{id}")
    Product selectSingleProduct(Integer id);
//    @Select("SELECT id,title,price,stock " +
//            "FROM product ")
    List<Product> selectManyProduct();


}
